When you open Microsoft Excel files that were created by the XLS engine, you might receive the following message:

Excel found unreadable content in 'yourfile.xls'.  Do you want to recover
the contents of this workbook. 
If you trust the source of this workbook click Yes. 

If you click the Yes button, only part of the data is displayed.

This problem occurs in Excel 2007 on 64-bit platforms and also in Excel 2010, on both 32-bit and 64-bit platforms. If you open the same file in Excel 2003, it opens correctly. The problem occurs because of the heading that is generated in the .xls file that is created by the SAS^® System.

To resolve the problem in the third maintenance release for SAS 9.2^® (TS2M3), add the statement option VERSION=2003 to your export code, as follows:

This solution works for Excel 2007 version 12.0.4518 or earlier.

If you have a version of Excel 2007 that is later than 12.0.4518, or if you are using Excel 2010, then you must do one of the following:

• Open the Excel file in Excel 2003 and resave the file.
• Use the EXCELCS driver with the SAS^® PC Files Server.
• Export the file to a different format, such as a .csv or a tab-delimited .txt file.

• It is a newer driver that does not use the SAS PC Files Server.
• It can export only one sheet per file.
• The entire XLSX file is replaced.
• In SAS 9.3 TS1M1, you are limited to 25 columns or less.

In SAS 9.3 TS1M2, there are no limitations except the one sheet per file

Operating System and Release Information